create external table jms_dm.dm_tab_inport_center_summary_dt
(

    scan_site_code  string comment '扫描网点code',
    scan_site_name  string comment '扫描网点',
    site_agent_code string comment '代理区code',
    site_agent_name string comment '代理区name',
    arr_num         int  comment '到件总量',
    weight_num      int  comment '称重票数',
    weight_pc_num   int  comment 'PC端称重票数',
    weight_yd_num   int  comment '内场APP称重票数',
    weight_jcd_num  int  comment '交叉带称重票数',
    date_time       int  comment '日期'
) COMMENT '中心进港称重报表'
    PARTITIONED BY (
        dt string COMMENT 't-2扫描时间')
    STORED AS parquet
    LOCATION
        '/dw/hive/jms_dm.db/external/dm_tab_inport_center_summary_dt'
;
